﻿using NPOI.HSSF.UserModel;
using NPOI.XSSF.UserModel;

namespace dpa.Library.Services;

public interface IExcelService
{
    HSSFWorkbook LoadExcel(string excelFilePath);
    
    Task<string> GetValueByRowNoAndCellNo(HSSFWorkbook workbook, int rowNo, string cellNo);

    Task<string> GetValueByRowNoAndCellNo(HSSFWorkbook workbook, int rowNo, int cellNo);

    Task<(int rowNo, int cellNo)?> FindKeyWordInColum(HSSFWorkbook workbook, int columnIndex, string keyWords);
}